﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Tabellen.aspx.cs" Inherits="Quaack.Tabellen" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
        Profile<br />
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="profileid" DataSourceID="QuaackProfile">
            <Columns>
                <asp:BoundField DataField="profileid" HeaderText="profileid" InsertVisible="False" ReadOnly="True" SortExpression="profileid" />
                <asp:BoundField DataField="username" HeaderText="username" SortExpression="username" />
                <asp:BoundField DataField="password" HeaderText="password" SortExpression="password" />
                <asp:BoundField DataField="profile" HeaderText="profile" SortExpression="profile" />
                <asp:BoundField DataField="email" HeaderText="email" SortExpression="email" />
                <asp:BoundField DataField="avatarlocation" HeaderText="avatarlocation" SortExpression="avatarlocation" />
                <asp:BoundField DataField="mobilenumber" HeaderText="mobilenumber" SortExpression="mobilenumber" />
                <asp:CheckBoxField DataField="verificationpending" HeaderText="verificationpending" SortExpression="verificationpending" />
                <asp:BoundField DataField="verficationpendingdatetime" HeaderText="verficationpendingdatetime" SortExpression="verficationpendingdatetime" />
                <asp:CheckBoxField DataField="tempblocked" HeaderText="tempblocked" SortExpression="tempblocked" />
                <asp:BoundField DataField="tempblockeddatetime" HeaderText="tempblockeddatetime" SortExpression="tempblockeddatetime" />
                <asp:CheckBoxField DataField="permblocked" HeaderText="permblocked" SortExpression="permblocked" />
                <asp:BoundField DataField="permblockeddatetime" HeaderText="permblockeddatetime" SortExpression="permblockeddatetime" />
                <asp:CheckBoxField DataField="removed" HeaderText="removed" SortExpression="removed" />
                <asp:BoundField DataField="removeddatetime" HeaderText="removeddatetime" SortExpression="removeddatetime" />
                <asp:CommandField ShowEditButton="True" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="QuaackProfile" runat="server" ConnectionString="<%$ ConnectionStrings:QuaackConnectionStringProfile %>" SelectCommand="SELECT * FROM [profile] ORDER BY [profileid]"></asp:SqlDataSource>
        <br />
        <br />
        Message<br />
        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="messid" DataSourceID="QuaackMessage">
            <Columns>
                <asp:BoundField DataField="messid" HeaderText="messid" InsertVisible="False" ReadOnly="True" SortExpression="messid" />
                <asp:BoundField DataField="messdatetime" HeaderText="messdatetime" SortExpression="messdatetime" />
                <asp:BoundField DataField="sender" HeaderText="sender" SortExpression="sender" />
                <asp:BoundField DataField="parentmessid" HeaderText="parentmessid" SortExpression="parentmessid" />
                <asp:BoundField DataField="message" HeaderText="message" SortExpression="message" />
                <asp:CheckBoxField DataField="removed" HeaderText="removed" SortExpression="removed" />
                <asp:BoundField DataField="removedby" HeaderText="removedby" SortExpression="removedby" />
                <asp:CommandField ShowEditButton="True" ShowSelectButton="True" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="QuaackMessage" runat="server" ConnectionString="<%$ ConnectionStrings:QuaackConnectionMessage %>" SelectCommand="SELECT * FROM [message] ORDER BY [messid]"></asp:SqlDataSource>
        <br />
        Follower<br />
        <br />
        <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" DataKeyNames="followid" DataSourceID="QuaackFollower">
            <Columns>
                <asp:BoundField DataField="followid" HeaderText="followid" InsertVisible="False" ReadOnly="True" SortExpression="followid" />
                <asp:BoundField DataField="subject" HeaderText="subject" SortExpression="subject" />
                <asp:BoundField DataField="follower" HeaderText="follower" SortExpression="follower" />
                <asp:CheckBoxField DataField="blocked" HeaderText="blocked" SortExpression="blocked" />
                <asp:CheckBoxField DataField="requestpending" HeaderText="requestpending" SortExpression="requestpending" />
                <asp:CommandField ShowEditButton="True" />
            </Columns>
        </asp:GridView>
        <asp:SqlDataSource ID="QuaackFollower" runat="server" ConnectionString="<%$ ConnectionStrings:Quaack %>" SelectCommand="SELECT * FROM [follower]"></asp:SqlDataSource>
        <br />
        <br />
        <br />
    
    </div>
    </form>
</body>
</html>
